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.
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
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,