How to remove double quotation in (output table) note pad?

[Raghu_km]

After data extract how to remove " in the report.
example:-
“bank name xyz, date of open xxxxx”

Already i used Read range–>output data table -->write text file

Thank you,
Raghu K M

[Gokul001 (Gokul Balaji)]

Hi @Raghu_km

How about this Regular expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=“)\S.*(?=”)").Tostring

Regards
Gokul

[Yoichi]

Hi,

How about the following?

strDt = String.Join(columnSeparater,dt.Columns.Cast(Of DataColumn).Select(Function(dc) dc.ColumnName))+vbcrlf+String.Join(vbcrlf,dt.AsEnumerable.Select(Function(r) String.Join(columnSeparater,r.ItemArray)))

Sequence.xaml (7.6 KB)

Regards,

[Raghu_km]

Thanks Gokul, do you have workflow for this.