Put a comma between city and state — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Put a comma between city and state

Received Response
41
Views
3
Comments
Alexander Restrepo
Alexander Restrepo Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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,

 

Answers