How to split a Excel column values using excel import function

0
I need to split a particular column in an excel file that contains integers and characters. This should be done while we import the excel file using the excel import function.
asked
2 answers
0

When adding columns to your import template, you can choose microflows to parse your data:

 

If you want to parse one column to more than one attribute, you can add the same column number several times in the column overview, but use different microflows to parse them with and save them to a different attribute.

 

answered
0

As an idea, you can run a parse microflow on a field that stores data from the column which then splits out the data into a string and integer. If you’re parsing Excel data into Entity A where attributeA stores whatever the value is inside the column, then you can create attributeB which will store an Integer. Finally, you would storejust  the string part in attributeA 

answered