Get details from text

Hi All,

I want to convert the below text to table or wanted to extract data thru regex.

MAA Distri Cal Distribution
DST # Account # Ticker CUT # Fund Paid Outstanding Rate/Share
9307 745336 MJAWE 83681P531 Callcal Term Miti Prop 2,485,126.08 74,193,631.799 0.03349514

1st row is heading
2nd is header
3rd is values

This text is extrated from pdf.

1 Like

@rishiathawale

try extracting with preserve formatting checked…then you can split using tab or cound the characters and split…as of now because of sentences it is difficult…with preserveformat you would get seggregation

cheers

Hi
Try with GENERATE DATATABLE activity where pass string as input and get datatavle as output

When u r extracting make sure they are with certain delimiter like tab or semi colon

Or

Use below Regex or split method

Use ADD DATAROW activity and pass the below array output as input to ArrayRow property and dt as datatable
Create that datatable with build datatable activity

For example

Split(Strinput.ToString, “#”).ToArray()

But this has to of same format

Else would recommend to extract that as csv from the end website you are using and use the above method of generate datatable activity

Hope this helps

Cheers @rishiathawale

Hi @rishiathawale ,
You can use “generic data table”
or
Convert to Array by Split(Strinput.ToString, “#”).ToArray()
my output
image

my input
" MAA Distri Cal Distribution
DST # Account # Ticker CUT # Fund Paid Outstanding Rate/Share
9307 745336 MJAWE 83681P531 Callcal Term Miti Prop 2,485,126.08 74,193,631.799 0.03349514"
my code
Sequence.xaml (9.3 KB)
regards,