General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Extract or Identify rows in a CSV File that are in between rows containing certain words

pohrt
7 - Meteor

Probably not such a difficult task but I tried for a while and also tried to find posts that might help me ...

This should work with Multi Row Formula .....

I have a huge long text/csv file and want to identify and extract the in-between Rows of Text that are starting with the ROW that CONTAINS "Start Error Messages" and ending with the ROW that CONTAINS "Start Error Messages".

Maybe somebody has a good idea here.

 

Field_1
bghjkjkjkjk

>>>
??
&&JKLUGGF

sdrtgggdfgfg
&&&&
Start Error Messages HHH
ghjhjkhkk
bkgfdc
tyu8900
567889

Finish Error Messages GGG
bbgghg
7890-===
345

 

Thanks, 

Petra

2 REPLIES 2
binuacs
20 - Arcturus

@pohrt one way of doing this

image.png

Qiu
21 - Polaris
21 - Polaris

@pohrt 
I have replied a similar question here. Maybe you can take a look. 😁

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/how-to-filter-out-a-chunk-of-d...

Labels