Help in converting a delimited data file (Tab) or as PDF file

ronmill66

New Member
Joined
Mar 24, 2018
Messages
1
Hi,

This is my first post and I hope I can get some help. I know the very basic of macros. I work on testing macros at home using excel 2003 vba, but at work I use a excel 2016. R3C2 is for a chk# or name/R3C1 is for 2 or 3 digit empl. #/R3c5 is information for adjusting transaction/r3c6 - r3c12 is for numbers/amts. currently I'm having to enter all postings manually in its respective spot. Below is an abbreviated file that is used. It is formated as Delimited and not delimited data. Help would be much appreciated.


IS_INTERNAL_YN INTERNAL_DEBIT INTERNAL_CREDIT FIRST FIRST_DEBIT FIRST_CREDIT SECOND SECOND_DEBIT SECOND_CREDIT THIRD THIRD_DEBIT THIRD_CREDIT EXP_DATE RECEIPT_NO GUEST_FULL_NAME TARGET_RESORT TRX_DESC MARKET_CODE BUSINESS_FORMAT_DATE BUSINESS_TIME BUSINESS_DATE REFERENCE TRX_NO CASHIER_DEBIT CASHIER_CREDIT ROOM CREDIT_CARD_SUPPLEMENT CURRENCY1 TRX_CODE CASHIER_ID REMARK INSERT_USER INSERT_DATE CHEQUE_NUMBER ROOM_CLASS CC_CODE CASHIER_NAME USER_NAME DEP_NET_TAX_AMT DEPOSIT_DEBIT CASH_ID_USER_NAME PRINT_CASHIER_DEBIT PRINT_CASHIER_CREDIT
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Gilmartin,Allan Pinon Grill Bkfst Food CTR 03-02-18 08:06 AM 02-MAR-18 Room# 246 : CHECK# 9771 [75] 115145150 -3.5 0 246 Room# 246 : CHECK# 9771 [75] USD 2000 2004 122 02-MAR-18 977120180302070953 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -3.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B CASH 9510 Pinon Grill Bkfst Food HSE 03-02-18 08:39 AM 02-MAR-18 CHECK# 9787 [75] 115145318 -3.5 0 9510 CHECK# 9787 [75] USD 2000 2004 122 02-MAR-18 978720180302083119 PI [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -3.5 0

N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B CASH 9510 Pinon Grill Lunch Food HSE 03-02-18 03:48 PM 02-MAR-18 CHECK# 9830 [81] 115149335 -1.5 0 9510 CHECK# 9830 [81] USD 2010 2004 122 02-MAR-18 983020180302153602 PI [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -1.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Bloomfield,Anthony Pinon Grill Lunch Food CTR 03-02-18 03:49 PM 02-MAR-18 Room# 338 : CHECK# 9827 [81] 115149339 -11 0 338 Room# 338 : CHECK# 9827 [81] USD 2010 2004 122 02-MAR-18 982720180302150323 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -11 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Williamson,Daniel Rm Svc Dinner Food CTR 03-02-18 04:28 PM 02-MAR-18 Room# 353 : CHECK# 4030 [81] 115149110 -4.63 0 353 Room# 353 : CHECK# 4030 [81] USD 2398 2004 122 02-MAR-18 403020180302155634 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -4.63 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miles,Paul Rm Svc Dinner Food CTR 03-02-18 04:29 PM 02-MAR-18 Room# 345 : CHECK# 4031 [81] 115149574 -3.5 0 345 Room# 345 : CHECK# 4031 [81] USD 2398 2004 122 02-MAR-18 403120180302155712 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -3.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Ehlers,Lesley Pinon Grill Lunch Food CTR 03-02-18 04:36 PM 02-MAR-18 Room# 355 : CHECK# 9841 [81] 115149601 -2.25 0 355 Room# 355 : CHECK# 9841 [81] USD 2010 2004 122 02-MAR-18 984120180302163422 DLX [Micros 9700 Enhanced] POS (200) OPERA-IFC 0 0 2004-OPERA-IFC -2.25 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Tax Pinon Grill Food-City HSE 03-02-18 02:49 AM 02-MAR-18 115166980 -.48 0 9518 CHK98907, COMP CHIPS FOR TABLE #90 USD 7230 3200 CHK98907, COMP CHIPS FOR TABLE #90 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -.48 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Lunch Food HSE 03-02-18 02:52 AM 02-MAR-18 115166981 -21.62 0 9518 CHK98917, PSPRT #601-88-2911 JAN/19 USD 2010 3200 CHK98917, PSPRT #601-88-2911 JAN/19 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -21.62 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Lunch Beer HSE 03-02-18 02:53 AM 02-MAR-18 115166982 -1.54 0 9518 CHK98917, PSPRT #601-88-2911 JAN/19 USD 2011 3200 CHK98917, PSPRT #601-88-2911 JAN/19 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.54 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Tax Pinon Grill Food-City HSE 03-02-18 02:53 AM 02-MAR-18 115166983 -1.84 0 9518 CHK98917, PSPRT #601-88-2911 JAN/19 USD 7230 3200 CHK98917, PSPRT #601-88-2911 JAN/19 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.84 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Dinner Food HSE 03-02-18 02:55 AM 02-MAR-18 115166984 -17.26 0 9518 CHK9870, REST.COM CERT#165303824 USD 2020 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -17.26 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Dinner Liquor HSE 03-02-18 02:56 AM 02-MAR-18 115166985 -1.88 0 9518 CHK9870, REST.COM CERT#165303824 USD 2022 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.88 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Pinon Grill Dinner Grat HSE 03-02-18 02:56 AM 02-MAR-18 115166986 -4.02 0 9518 CHK9870, REST.COM CERT#165303824 USD 2026 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -4.02 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 Miscellaneous, 9518 Tax Pinon Grill Food-City HSE 03-02-18 02:56 AM 02-MAR-18 115166987 -1.84 0 9518 CHK9870, REST.COM CERT#165303824 USD 7230 3200 CHK9870, REST.COM CERT#165303824 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -1.84 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B Visa 9512 Tax Pinon Grill Food-City HSE 03-02-18 03:01 AM 02-MAR-18 115166988 -2.5 0 9512 CHK9811, SERVER CLOSED WRONG CHECK AND RECALCUATED TAX USD 7230 3200 CHK9811, SERVER CLOSED WRONG CHECK AND RECALCUATED TAX 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -2.5 0
N -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 -742.67 -483.02 F&B Visa 9512 Pinon Grill Lunch Grat HSE 03-02-18 03:14 AM 02-MAR-18 115166990 -5.38 0 9512 CHK9811, SERVER ADJUSTED CHK TO PUT DISCOUNT. BUT UNABLE TO REOPEN CHK PROPERLY. THEREFORE, DID NOT CORRECTLY CALCULATE. USD 2016 3200 CHK9811, SERVER ADJUSTED CHK TO PUT DISCOUNT. BUT UNABLE TO REOPEN CHK PROPERLY. THEREFORE, DID NOT CORRECTLY CALCULATE. 6796 03-MAR-18 PI Brendon Lawerence 200BRL 0 0 3200-200BRL -5.38 0
R_DEBIT R_CREDIT LOGO
-742.67 -483.02
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,109,341
Messages
5,528,146
Members
409,803
Latest member
Jeff abby

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top