You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Loading Multi period figures

Accepted answer
17
Views
3
Comments
edited Feb 22, 2021 6:05PM in Financial Consolidation and Close 3 comments

Summary

Loading Multi period figures

Content

Hi All,

i need to implement an interface by using "Data Management" in FCCS in order to load figures of 12 months for a specific Scenario.

The flat file is so structured:

40100500;8242784.4543119659647346;18176495.3702085986733437;29476935.4315394945442677;41251764.2565488964319229;52431570.0960358381271362;63553150.7032765373587608;74871045.2016624212265015;80719476.4813297241926193;91854263.4727744311094284;102673576.1997397094964981;112833673.2541695386171341;120808678.3143073320388794;"FY21;CE_BDG;V1;0A000000;LE-100;Input;InputAcc;YTD";GEST

We have data for 12 months and at the end we have the POV.

As showed, the POV starts with ". This is a problem because all fields between two " is considered an unique string:

"FY21;CE_BDG;V1;0A000000;LE-100;Input;InputAcc;YTD"

Is there a way to exclude the character " at the start / end of the string?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!