~Out data extraction credit~(1,200.00)
This is the sample data I’m getting after performing regex. But it is coming all together, We need above data in seperate line .Can anyone help me to solve this issue.
Can you share the Output for the above input text?
Do you want to separate data with ~ and write each line to a separate column?
You can watch the below video to do that. If the requirement is different please share the input file and the output file required.
you can use Text to column activity or Generate datatable activity.
test.txt (111 Bytes)
I used this regex in matches activity. we used single line flag.
How about expression?
Arr_Str(Array of String)=YourOutputVariable.Split(Environment.Newline.TocharArray,StringSplitOptions.RemoveEmptyEntities)
if you want 1st line
Follow Same For the Remaining Lines.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.