topic Re: Add double quote to string/substring in App Development

Add double quote to string/substring

sfbi — Sat, 16 Nov 2024 18:24:26 GMT

Hi,

How do I add double quotes to each word into a string.

vSelectFields = ' IDFIELD, NMFIELD, DTFIELD '

TO
vSelectFields = ' "IDFIELD", "NMFIELD", "DTFIELD" '

Thank you,
Henrique

Or — Tue, 07 Jul 2020 13:13:09 GMT

[Edit]: Misunderstood the question, deleting the post

Taoufiq_Zarra — Tue, 07 Jul 2020 13:10:10 GMT

one option :

='"'&replace(vSelectFields,',','","')&'"'

output :

sfbi — Tue, 07 Jul 2020 13:35:41 GMT

@Taoufiq_Zarra

Thank you! I've just made some minor changes to get the spaces between each field...

='"'&replace(vSELECT,', ','", "')&'"';