LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Fixed file with no column names

    Employee
    Posted 02-08-2012 10:05

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Kathleen McGuigan

    Hi,
    Is there a way to create a fixed file with no delimiters, no column names with header (fixed + variable date) and footer records (fixed + record count)? An example of the layout is attached. The end file also should also have no file extension, if possible.
    Thanks,
    Kathleen
    Attachments:
    BLSTH#K#MF05#XFA03#I088E.txt


  • 2.  RE: Fixed file with no column names

    Employee
    Posted 02-08-2012 10:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Sure, you would do it with string manipulation to create a "line" field with your data, and then output that using delimited or fixed, I think. I attached a graph that should give you the idea of what I mean (not sure how your actual data is, so formatting will obviously need to be tweaked).

    Cheers
    Rich
    Attachments:
    exampleFormatedOutput.brg


  • 3.  RE: Fixed file with no column names

    Employee
    Posted 02-08-2012 12:08

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Kathleen McGuigan

    Thanks for the quick response! This should work but I am having trouble figuring out what record demiliter would move the records to the subsequent row. The data needs to be in fixed positions.


  • 4.  RE: Fixed file with no column names

    Employee
    Posted 02-08-2012 12:14

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    If I understand, I think you want a record delimiter of "\n" If this isn't what you want, it would be helpful if you can post example data from before (Data in LAE) and after it is written the desired way, similar to how you provided above.

    Cheers
    Rich


  • 5.  RE: Fixed file with no column names

    Employee
    Posted 02-08-2012 12:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Kathleen McGuigan

    Thanks, this attachment is input. The one I previously posted was the desired output.


  • 6.  RE: Fixed file with no column names

    Employee
    Posted 02-09-2012 07:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Kathleen, you missed the attachment

    Cheers
    Rich


  • 7.  RE: Fixed file with no column names

    Employee
    Posted 02-09-2012 07:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Kathleen McGuigan

    Sorry about that, not sure it is taking though since i don't see .csv as a valid file extension. Just in case, attaching as .txt but it is being input as csv. Thanks.

    I am unable to attach either. Getting this message "Your submission could not be processed because a security token was missing.

    If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.
    ".

    I am actually unable to submit this message, tells me to "complete both the subject and message fields." These fields are filled out, don't know why it is not seeing the data all of the sudden.

    IT just upgraded Websense last night, needed to import a cert. Sorry!
    Attachments:
    TN_408D_Temp.txt