Summary Put a comma between city and state Content Hi, I have a RTF template. Field contains 3 data: * City Name (variable length) * State Initials (fixed 2 Chars) * Zip Code (variable from 5 to 10 chars) I need to place a comma between city name and state Example: Source: Vegas NV 0000 Result: Vegas, NV 0000 Any help will be appreciated. Regards,

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Put a comma between city and state

Alexander Restrepo

Summary

Put a comma between city and state

Content

Hi,

I have a RTF template.

Field contains 3 data:

City Name (variable length)
State Initials (fixed 2 Chars)
Zip Code (variable from 5 to 10 chars)

I need to place a comma between city name and state

Example:

Source:

<Address_ID30>Vegas NV 0000</Address_ID30>

Result:

Vegas, NV 0000

Any help will be appreciated.

Regards,

Find more posts tagged with

Accepted answers

All comments

User910243567

Suggest you to handle this at query level and get the final xml tag as <Addr3>Vegas, NV 00000</Addr3>.

Otherwise you can try using Instr and replace function. (i.e find the first space and replace it with ',')

Refer this https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481158.htm

Anandula

you can try <city>,<state> tags in template

Anandula

you can try <state>,<city> tags in template