Transfer Tabs from input file to Output file

Question

Hello,

My Input file have multiple tabs and few tabs i need to transfer into my output file (with same format- table, highlighted rows). i use this formula below with formula tool but then it takes all other tabs into my output file

REGEX_Replace([FileName], "\|\|\|.+", "|||New Sheet")

For example- i want to transfer these two tabs name -John, Bob into output file out of eight tabs from input file but when i use this formula above it takes all eight tabs  into output file.

can you show me how can we transfer these two tabs John & Bob out of eight tabs from input file to output file. Also i want to keep on same format.

kauser · Answer

This is my input tab that i want to move into output file but every time i tried its come out in a different formar. such as when i transfer into to output file data come without $sign and also lost % . i want to mirror the data from input tab to output tab

ItemJANUARYFEBRUARYMARCHAPRILMAYJUNE1 $                4,578.00 $               458.00 $              1,245.00 $                    93,124.00 $                4,786.00 $                4,589.002 $              22,890.00 $           2,290.00 $              6,225.00 $                  465,620.00 $              23,930.00 $              22,945.003 $              45,780.00 $           4,580.00 $           12,450.00 $                  931,240.00 $              47,860.00 $              45,890.004                 41,202.00               4,122.00               11,205.00                     838,116.00                 43,074.00                 41,301.005               114,450.00            11,450.00               31,125.00                  2,328,100.00               119,650.00               114,725.006                 91,560.00               9,160.00               24,900.00                  1,862,480.00                 95,720.00                 91,780.007       419,161,680.00       4,195,280.00       31,000,500.00      173,441,587,520.00       458,115,920.00       421,178,420.0084.00%48.00%81.00%65.00%20.00%58.00%9       419,047,230.00       4,183,830.00       30,969,375.00      173,439,259,420.00       457,996,270.00       421,063,695.0010               114,450.00            11,450.00               31,125.00                  2,328,100.00               119,650.00               114,725.00

cjaneczko · Answer

Bring the tab names in as a Field on the input tool.

kauser · Answer

Thanks ..... But how can we filter out tabs from an input file. please advice.