I want to convert US States Full Names into Abbreviations

Hi Community,

I want to convert the fill name of the US states into Abbreviations (For instance, Maryland to MD and so forth). In the ‘state’ column, I want to see the abbreviations. Here is my sample input file. Can anyone help? Thanks!
InputFile_States.xlsx (9.7 KB)

One of many options:

Create a lookup dictionary eg. by JSON input:

if needed Swap name and state code

then use a or each row and change the statename to the state code

Hello @Sisay_Dinku

You can keep in an excel file or a json file and convert that to a dictionary.

Then use the country name as the key to get the abbreviation.

Thanks

@Rahul_Unnikrishnan

Could you put that in the flow? I could quite get it.

Can anyone help with this?

@Sisay_Dinku
New Microsoft Excel Worksheet.xlsx (11.5 KB)
This is the excel sheet with states and its abbreviation
here is the workflow
Workflow.xaml (7.8 KB)

@sangeethaneelavannan1 Thank you for the dictionary. I want to make it clear that I want the abbreviations are expected to be written sate names in the State Sheet from the States_abbr sheet after the vlookup. I am attaching the example.
Sates_VlookUp.xlsx (17.0 KB)
Thanks

@sangeethaneelavannan1 I use modern design

@Sisay_Dinku Workflow.xaml (10.6 KB)

@sangeethaneelavannan1 That was excellent. It has worked. I’ll mark this as a solution. Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.