Convert An Extract File From .Txt To .Csv

By default, the application generates the extracted file with a .txt extension. Manually change the file extension to .csv when saving it to locally.

For scheduled extract flows with an FTP server, the file conversion doesn't happen automatically. Therefore, you can create a custom Fast Formula to convert the files into the required format.

Follow these steps to create a custom formula for file naming conversion:

1. Search for and select Fast Formulas in My Client Groups.

2. Click ‘+’ to create a fast formula.

3. Enter these values:

   1. Enter Formula Name: Any Name ( Use the WFN File Name).

   2. Type: Extract Rule.

   3. Description: Enter the description.

   4. Legislative Data Group: Enter your LDG name

4. Click Continue and enter the following logic in the text editor:

   DEFAULT FOR RULE_VALUE IS ' '
   l_dob = DATE_TO_TEXT(GET_SYSDATE(),'MM_DD_YY_HH_MM_SS')
   l_final_value='WFNUVI_EE_'+l_dob +'.csv' RULE_VALUE = l_final_value
   RETURN RULE_VALUE
   

5. Compile the formula.